# Address table, text file name ADD.CSV
# 
# Column
# sequence Column name  Type     Size  Description
# -------- ------------ -------  ----  ---------------------
# 1        Ent_num      number         link to unique listing
# 2        Add_num      number         unique record identifier
# 3        Address      text     750   street address of SDN
# 4        City         text     50    city of address
# 5        Country      text     250   country of address
# 6        Add_remarks  text     200   remarks on address
class CreateAddresses < ActiveRecord::Migration
  def self.up
    create_table :addresses do |t|
      t.integer 'name_id'
      t.string 'address'
      t.string 'city'
      t.string 'country'
      t.text 'remarks'
      t.timestamps
    end
  end

  def self.down
    drop_table :addresses
  end
end
